/opt/module/sqoop/bin/sqoop export \
--connect 'jdbc:mysql://node101:3306/gd2_tmp_hive?useUnicode=true&characterEncoding=utf-8' \
--username root \
--password 123456 \
--table dim_traffic_source_top10 \
--export-dir /user/spark/warehouse/gd2_tmp_hive/dim_traffic_source_top10 \
--update-mode allowinsert \
--update-key 'source_type,visitor_count,pay_conversion' \
--fields-terminated-by '\001' \
--input-null-non-string '\\N' \
--input-null-string '\\N' \
--num-mappers 1



/opt/module/sqoop/bin/sqoop export \
--connect 'jdbc:mysql://node101:3306/gd2_tmp_hive?useUnicode=true&characterEncoding=utf-8' \
--username root \
--password 123456 \
--table dim_sku_sales_top5 \
--export-dir /user/spark/warehouse/gd2_tmp_hive/dim_sku_sales_top5 \
--update-mode allowinsert \
--update-key 'sku_id,sku_info,pay_count' \
--fields-terminated-by '\001' \
--input-null-non-string '\\N' \
--input-null-string '\\N' \
--num-mappers 1



/opt/module/sqoop/bin/sqoop export \
--connect 'jdbc:mysql://node101:3306/gd2_tmp_hive?useUnicode=true&characterEncoding=utf-8' \
--username root \
--password 123456 \
--table dim_search_word_top10 \
--export-dir /user/spark/warehouse/gd2_tmp_hive/dim_search_word_top10 \
--update-mode allowinsert \
--update-key 'search_word,visitor_count' \
--fields-terminated-by '\001' \
--input-null-non-string '\\N' \
--input-null-string '\\N' \
--num-mappers 1


/opt/module/sqoop/bin/sqoop export \
--connect 'jdbc:mysql://node101:3306/gd2_tmp_hive?useUnicode=true&characterEncoding=utf-8' \
--username root \
--password 123456 \
--table dim_price_strength_daily_top10 \
--export-dir /user/spark/warehouse/gd2_tmp_hive/dim_price_strength_daily_top10 \
--update-mode allowinsert \
--update-key 'dt,product_name,price_strength' \
--fields-terminated-by '\001' \
--input-null-non-string '\\N' \
--input-null-string '\\N' \
--num-mappers 1
